﻿CREATE TABLE [dbo].[Route] (
    [Route_no]       NVARCHAR (10) NULL,
    [Stop_No]        SMALLINT      NULL,
    [stop_name]      NVARCHAR (25) NULL,
    [Area]           NVARCHAR (50) NULL,
    [Sector]         NVARCHAR (20) NULL,
    [Location]       NVARCHAR (75) NULL,
    [No_of_students] SMALLINT      NULL,
    [Charge_Code]    NVARCHAR (5)  NULL
);

